<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
</head>
<body>
<table border="1" align="center" width="600px">
    <tr>
        <th>id</th>
        <th>姓名</th>
        <th>年龄</th>
        <th>地址</th>
        <th>手机号</th>
        <th>职业</th>
        <th>操作</th>
    </tr>

<?php
$server="localhost";
$name="root";
$pwd="123456";
$db="aliya";

$con=mysqli_connect($server,$name,$pwd,$db);
if($con){
    $sql="select * from aliya1";
    $run=mysqli_query($con,$sql);
    if(mysqli_num_rows($run)>0){
         while ($kur=mysqli_fetch_assoc($run)){
        $id=$kur['id'];
        echo "<tr>";
            echo "<td>". $kur['id'] ."</td>";
            echo "<td>". $kur['name'] ."</td>";
            echo "<td>". $kur['age'] ."</td>";
            echo "<td>". $kur['ads'] ."</td>";
            echo "<td>". $kur['tel'] ."</td>";
            echo "<td>". $kur['kaspi'] ."</td>";
            echo "<td><a href='2149.php?id=$id'>编辑</a></td>";
            echo "</tr>";
    }
}


}else{
    echo "未连接数据库，错误内容：".mysqli_connect_error();
}

?>
</table>
</body>
</html>